articles

home / developersection / articles / create table in microsoft sql server

Create Table in Microsoft SQL Server

Anonymous User 5201 18-Jul-2010
Syntax to create table in MSSQl Server2008
CREATE TABLE table
[name](
Column1,
Column2,
Column3)
Example

Customers  is the name of table.

CREATE TABLE Customers (
DrvLicNbr nvarchar(32),
DateIssued DATE,
DateExpired date,
FullName nvarchar(50),
Address NVARCHAR(120),
City NvarChar(40),
State NVarChar(50),
PostalCode nvarchar(20),
HomePhone nvarchar(20),
 OrganDonor BIT
);
 

 


Updated 04-Mar-2020

I am a content writter !

Leave Comment

1 Comments

Comments

Liked By